FO_CPTReviewCombinedDx
This table contains rules, records, for each CPT code and insurance carrier that will have a supporting diagnosis.
A default rule is required for each CPT code and insurance carrier pair.
The default rule must have the ICD field set as 'ALL' and the Reason field set to a value of 1 or 2. This default rule is required so that the system can assume that the test will fail LMRP checking for all conditions that are not defined in the FO_CPTReviewCombinedDx table.
A maximum of four (4) records may be created for each CPT code. (what/how is this enforced?)
| Field | Type | Notes |
|---|---|---|
|
CPTREvMultiDX_ID |
int |
ID field, a counter. Unique |
|
Carrier |
varchar(50) |
Code for the insurance carrier FI to which this CPT ICD pair will be assigned. Enter a valid insurance carrier code. (what does FI mean and is it really needed here?) |
|
Region |
int |
Region user assigned to. Enter a valid region as defined in the FO_Users table. |
|
ChargeTo |
varchar(50) |
Informational (any other info to give or what needs to be entered here?) |
|
CPT |
varchar(15) |
CPT code. Enter a valid CPT code. |
|
StartDate |
datetime |
Date rule put into use. Enter a valid date in MM/DD/YYYY format. |
|
StopDate |
datetime |
Date rule removed from use. Enter a valid date in MM/DD/YYYY format. |
|
DiagnosisCode |
varchar(50) |
Defines list of ICD codes that are payable. Multidimensional COMMA delimited list, no leading or trailing commas. (true?) Enter valid diagnosis, ICD, codes separated by commas. |
|
CreateDate |
datetime |
System timestamp when record is created. Informational |
|
EditDate |
datetime |
System timestamp when record is edited. Informational |
|
DiagCodingMethod |
varchar(50) |
*** NEED DEFINITION *** |